﻿CREATE TABLE [dbo].[TabExtMailLog] (
    [LogID]      numeric(18,0) NOT NULL identity(1, 1),
    [UserID]     numeric(18,0) NOT NULL,
    [LogData]    datetime      NOT NULL,
    [LogMessage] nvarchar(500) COLLATE Chinese_PRC_CI_AS NOT NULL,

    CONSTRAINT [PK_TabMailLog] PRIMARY KEY CLUSTERED ([LogID] asc),
    CONSTRAINT [FK_TabMailLog_TabUser] FOREIGN KEY ([UserID]) REFERENCES [dbo].[TabAccountIndex] ([UserID]) ON DELETE CASCADE ON UPDATE CASCADE
);
GO
